Convert existing stock items to styles

You should now have a retail hierarchy that uses the product groups from Sage 200 Accounts as well as the standard stock items in it. You should also have product groups that have been amended in the hierarchy so that they are now variant product groups (as opposed to standard stock item product groups).

Next, you can add the style level. Once created, you can move stock items from the product group down a level in the hierarchy into the style level and then convert them into variants.

The style level is similar to the setup of the standard stock item (with locations, suppliers, attachments, etc.). As Sage 200 Accounts does not use styles in stock records, this information can only be held in the retail (RTL) tables.

When creating the style type, the import routine will take the characteristics of the first stock item in the group as the template for the rest of the styles.

The exception to this is for supplier stock items. The style will contain all the suppliers for the stock items in the group. The preferred supplier details will be the details from the first stock item in the CSVComma Separated Value (CSV) file format. Sage 200 can import and export data in the CSV file format. file.

Once the styles category is created in the hierarchy, you must move the existing stock item records from the product group to the new style.

It is not necessary to move all of the items into a style. You can use a mix of styles and standard items in a product group. However, for consistency, we recommend that you ensure that a product group with dimensions only contains styles/variants or standard stock items. You should not have a product group with both.

The CSV file used in the migration contains 5 columns:

Stock Item Code

Style Name

Dimension value 1

Dimension Value 2

Dimension Value 3

For example:

BLUEJEAN3232	JEAN1	32	32	Blue
BLUEJEAN3432	JEAN1	34	32	Blue
BLACKJEAN3234	JEAN1	32	34	Black
BLACKJEAN3434	JEAN1	34	34	Black

The order of the values is based on the order of the dimensions when they were added to the product group (see the previous section, Adding dimensions on page 4 for more details).